{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true,
    "pycharm": {
     "is_executing": false
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "outputs": [
    {
     "data": {
      "text/plain": "                                               title  \\\n0          Medical education in the time of COVID-19   \n1  An evolution-based model for designing chorism...   \n2              AI, Machine Learning and the Pandemic   \n3  Enabling the assessment of trauma-induced hemo...   \n4  Mapping of host-parasite-microbiome interactio...   \n\n                                   author_time  \\\n0   By Diane B. Wayne, et al. | Jul 30th, 2020   \n1  By William P. Russ, et al. | Jul 25th, 2020   \n2               By Derek Lowe | Jul 24th, 2020   \n3     By Jonathan Zia, et al. | Jul 23rd, 2020   \n4       By E. Hossain, et al. | Jul 23rd, 2020   \n\n                                             ab_info  \\\n0  The preclinical curriculum was migrated online...   \n1  Learning from evolution Protein sequences cont...   \n2  It’s not surprising that there have been many ...   \n3  Using a machine learning approach, the most co...   \n4  Mapping of host-parasite-microbiome interactio...   \n\n                                 DOI                           pulish  \\\n0        DOI: 10.1126/sciadv.abc7110  Science Advances Vol. 6, No. 31   \n1       DOI: 10.1126/science.aba3304       Science Vol. 369, No. 6502   \n2  DOI: 10.1126/scitranslmed.abd9789                             None   \n3        DOI: 10.1126/sciadv.abb1708  Science Advances Vol. 6, No. 30   \n4        DOI: 10.1126/sciadv.aaz2015  Science Advances Vol. 6, No. 30   \n\n                       classes  \\\n0  Perspectives and commentary   \n1         Research and reviews   \n2                        Blogs   \n3         Research and reviews   \n4         Research and reviews   \n\n                                           info_link pdf_link  \n0  https://advances.sciencemag.org/content/6/31/e...     None  \n1  https://science.sciencemag.org/content/369/650...     None  \n2  https://blogs.sciencemag.org/pipeline/archives...     None  \n3  https://advances.sciencemag.org/content/6/30/e...     None  \n4  https://advances.sciencemag.org/content/6/30/e...     None  ",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>title</th>\n      <th>author_time</th>\n      <th>ab_info</th>\n      <th>DOI</th>\n      <th>pulish</th>\n      <th>classes</th>\n      <th>info_link</th>\n      <th>pdf_link</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>Medical education in the time of COVID-19</td>\n      <td>By Diane B. Wayne, et al. | Jul 30th, 2020</td>\n      <td>The preclinical curriculum was migrated online...</td>\n      <td>DOI: 10.1126/sciadv.abc7110</td>\n      <td>Science Advances Vol. 6, No. 31</td>\n      <td>Perspectives and commentary</td>\n      <td>https://advances.sciencemag.org/content/6/31/e...</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>An evolution-based model for designing chorism...</td>\n      <td>By William P. Russ, et al. | Jul 25th, 2020</td>\n      <td>Learning from evolution Protein sequences cont...</td>\n      <td>DOI: 10.1126/science.aba3304</td>\n      <td>Science Vol. 369, No. 6502</td>\n      <td>Research and reviews</td>\n      <td>https://science.sciencemag.org/content/369/650...</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>AI, Machine Learning and the Pandemic</td>\n      <td>By Derek Lowe | Jul 24th, 2020</td>\n      <td>It’s not surprising that there have been many ...</td>\n      <td>DOI: 10.1126/scitranslmed.abd9789</td>\n      <td>None</td>\n      <td>Blogs</td>\n      <td>https://blogs.sciencemag.org/pipeline/archives...</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>Enabling the assessment of trauma-induced hemo...</td>\n      <td>By Jonathan Zia, et al. | Jul 23rd, 2020</td>\n      <td>Using a machine learning approach, the most co...</td>\n      <td>DOI: 10.1126/sciadv.abb1708</td>\n      <td>Science Advances Vol. 6, No. 30</td>\n      <td>Research and reviews</td>\n      <td>https://advances.sciencemag.org/content/6/30/e...</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>Mapping of host-parasite-microbiome interactio...</td>\n      <td>By E. Hossain, et al. | Jul 23rd, 2020</td>\n      <td>Mapping of host-parasite-microbiome interactio...</td>\n      <td>DOI: 10.1126/sciadv.aaz2015</td>\n      <td>Science Advances Vol. 6, No. 30</td>\n      <td>Research and reviews</td>\n      <td>https://advances.sciencemag.org/content/6/30/e...</td>\n      <td>None</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "metadata": {},
     "output_type": "execute_result",
     "execution_count": 3
    }
   ],
   "source": [
    "df = pd.read_csv('./machine learning.csv')\n",
    "df.head(5)"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n",
     "is_executing": false
    }
   }
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "outputs": [
    {
     "data": {
      "text/plain": "                                                title  \\\n0           Medical education in the time of COVID-19   \n1   An evolution-based model for designing chorism...   \n2               AI, Machine Learning and the Pandemic   \n3   Enabling the assessment of trauma-induced hemo...   \n4   Mapping of host-parasite-microbiome interactio...   \n..                                                ...   \n95  Mixed-conducting particulate composites for so...   \n96  Overcoming immiscibility toward bimetallic cat...   \n97  Cellular contractile forces are nonmechanosens...   \n98  Balancing volumetric and gravimetric uptake in...   \n99                          Robots with insect brains   \n\n                                          author_time  \\\n0          By Diane B. Wayne, et al. | Jul 30th, 2020   \n1         By William P. Russ, et al. | Jul 25th, 2020   \n2                      By Derek Lowe | Jul 24th, 2020   \n3            By Jonathan Zia, et al. | Jul 23rd, 2020   \n4              By E. Hossain, et al. | Jul 23rd, 2020   \n..                                                ...   \n95  By Patricia Jastrzebska-Perfect, et al. | Apr ...   \n96          By Chunpeng Yang, et al. | Apr 23rd, 2020   \n97               By Lea Feld, et al. | Apr 23rd, 2020   \n98            By Zhijie Chen, et al. | Apr 18th, 2020   \n99                   By Barbara Webb | Apr 18th, 2020   \n\n                                              ab_info  \\\n0   The preclinical curriculum was migrated online...   \n1   Learning from evolution Protein sequences cont...   \n2   It’s not surprising that there have been many ...   \n3   Using a machine learning approach, the most co...   \n4   Mapping of host-parasite-microbiome interactio...   \n..                                                ...   \n95  Mixed-conducting particulate composites for so...   \n96  Overcoming immiscibility toward bimetallic cat...   \n97  Cellular contractile forces are nonmechanosens...   \n98  Balancing volumetric and gravimetric uptake in...   \n99  However, the ultimate test of mechanistic unde...   \n\n                                  DOI                           pulish  \\\n0         DOI: 10.1126/sciadv.abc7110  Science Advances Vol. 6, No. 31   \n1        DOI: 10.1126/science.aba3304       Science Vol. 369, No. 6502   \n2   DOI: 10.1126/scitranslmed.abd9789                             None   \n3         DOI: 10.1126/sciadv.abb1708  Science Advances Vol. 6, No. 30   \n4         DOI: 10.1126/sciadv.aaz2015  Science Advances Vol. 6, No. 30   \n..                                ...                              ...   \n95        DOI: 10.1126/sciadv.aaz6767  Science Advances Vol. 6, No. 17   \n96        DOI: 10.1126/sciadv.aaz6844  Science Advances Vol. 6, No. 17   \n97        DOI: 10.1126/sciadv.aaz6997  Science Advances Vol. 6, No. 17   \n98       DOI: 10.1126/science.aaz8881       Science Vol. 368, No. 6488   \n99       DOI: 10.1126/science.aaz6869       Science Vol. 368, No. 6488   \n\n                        classes  \\\n0   Perspectives and commentary   \n1          Research and reviews   \n2                         Blogs   \n3          Research and reviews   \n4          Research and reviews   \n..                          ...   \n95         Research and reviews   \n96         Research and reviews   \n97         Research and reviews   \n98         Research and reviews   \n99  Perspectives and commentary   \n\n                                            info_link pdf_link  \n0   https://advances.sciencemag.org/content/6/31/e...     None  \n1   https://science.sciencemag.org/content/369/650...     None  \n2   https://blogs.sciencemag.org/pipeline/archives...     None  \n3   https://advances.sciencemag.org/content/6/30/e...     None  \n4   https://advances.sciencemag.org/content/6/30/e...     None  \n..                                                ...      ...  \n95  https://advances.sciencemag.org/content/6/17/e...     None  \n96  https://advances.sciencemag.org/content/6/17/e...     None  \n97  https://advances.sciencemag.org/content/6/17/e...     None  \n98  https://science.sciencemag.org/content/368/648...     None  \n99  https://science.sciencemag.org/content/368/648...     None  \n\n[100 rows x 8 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>title</th>\n      <th>author_time</th>\n      <th>ab_info</th>\n      <th>DOI</th>\n      <th>pulish</th>\n      <th>classes</th>\n      <th>info_link</th>\n      <th>pdf_link</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>Medical education in the time of COVID-19</td>\n      <td>By Diane B. Wayne, et al. | Jul 30th, 2020</td>\n      <td>The preclinical curriculum was migrated online...</td>\n      <td>DOI: 10.1126/sciadv.abc7110</td>\n      <td>Science Advances Vol. 6, No. 31</td>\n      <td>Perspectives and commentary</td>\n      <td>https://advances.sciencemag.org/content/6/31/e...</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>An evolution-based model for designing chorism...</td>\n      <td>By William P. Russ, et al. | Jul 25th, 2020</td>\n      <td>Learning from evolution Protein sequences cont...</td>\n      <td>DOI: 10.1126/science.aba3304</td>\n      <td>Science Vol. 369, No. 6502</td>\n      <td>Research and reviews</td>\n      <td>https://science.sciencemag.org/content/369/650...</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>AI, Machine Learning and the Pandemic</td>\n      <td>By Derek Lowe | Jul 24th, 2020</td>\n      <td>It’s not surprising that there have been many ...</td>\n      <td>DOI: 10.1126/scitranslmed.abd9789</td>\n      <td>None</td>\n      <td>Blogs</td>\n      <td>https://blogs.sciencemag.org/pipeline/archives...</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>Enabling the assessment of trauma-induced hemo...</td>\n      <td>By Jonathan Zia, et al. | Jul 23rd, 2020</td>\n      <td>Using a machine learning approach, the most co...</td>\n      <td>DOI: 10.1126/sciadv.abb1708</td>\n      <td>Science Advances Vol. 6, No. 30</td>\n      <td>Research and reviews</td>\n      <td>https://advances.sciencemag.org/content/6/30/e...</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>Mapping of host-parasite-microbiome interactio...</td>\n      <td>By E. Hossain, et al. | Jul 23rd, 2020</td>\n      <td>Mapping of host-parasite-microbiome interactio...</td>\n      <td>DOI: 10.1126/sciadv.aaz2015</td>\n      <td>Science Advances Vol. 6, No. 30</td>\n      <td>Research and reviews</td>\n      <td>https://advances.sciencemag.org/content/6/30/e...</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>95</th>\n      <td>Mixed-conducting particulate composites for so...</td>\n      <td>By Patricia Jastrzebska-Perfect, et al. | Apr ...</td>\n      <td>Mixed-conducting particulate composites for so...</td>\n      <td>DOI: 10.1126/sciadv.aaz6767</td>\n      <td>Science Advances Vol. 6, No. 17</td>\n      <td>Research and reviews</td>\n      <td>https://advances.sciencemag.org/content/6/17/e...</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>96</th>\n      <td>Overcoming immiscibility toward bimetallic cat...</td>\n      <td>By Chunpeng Yang, et al. | Apr 23rd, 2020</td>\n      <td>Overcoming immiscibility toward bimetallic cat...</td>\n      <td>DOI: 10.1126/sciadv.aaz6844</td>\n      <td>Science Advances Vol. 6, No. 17</td>\n      <td>Research and reviews</td>\n      <td>https://advances.sciencemag.org/content/6/17/e...</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>97</th>\n      <td>Cellular contractile forces are nonmechanosens...</td>\n      <td>By Lea Feld, et al. | Apr 23rd, 2020</td>\n      <td>Cellular contractile forces are nonmechanosens...</td>\n      <td>DOI: 10.1126/sciadv.aaz6997</td>\n      <td>Science Advances Vol. 6, No. 17</td>\n      <td>Research and reviews</td>\n      <td>https://advances.sciencemag.org/content/6/17/e...</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>98</th>\n      <td>Balancing volumetric and gravimetric uptake in...</td>\n      <td>By Zhijie Chen, et al. | Apr 18th, 2020</td>\n      <td>Balancing volumetric and gravimetric uptake in...</td>\n      <td>DOI: 10.1126/science.aaz8881</td>\n      <td>Science Vol. 368, No. 6488</td>\n      <td>Research and reviews</td>\n      <td>https://science.sciencemag.org/content/368/648...</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>99</th>\n      <td>Robots with insect brains</td>\n      <td>By Barbara Webb | Apr 18th, 2020</td>\n      <td>However, the ultimate test of mechanistic unde...</td>\n      <td>DOI: 10.1126/science.aaz6869</td>\n      <td>Science Vol. 368, No. 6488</td>\n      <td>Perspectives and commentary</td>\n      <td>https://science.sciencemag.org/content/368/648...</td>\n      <td>None</td>\n    </tr>\n  </tbody>\n</table>\n<p>100 rows × 8 columns</p>\n</div>"
     },
     "metadata": {},
     "output_type": "execute_result",
     "execution_count": 4
    }
   ],
   "source": [
    "df\n"
   ],
   "metadata": {
    "collapsed": false,
    "pycharm": {
     "name": "#%%\n",
     "is_executing": false
    }
   }
  }
 ],
 "metadata": {
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  },
  "kernelspec": {
   "name": "python3",
   "language": "python",
   "display_name": "Python 3"
  },
  "pycharm": {
   "stem_cell": {
    "cell_type": "raw",
    "source": [],
    "metadata": {
     "collapsed": false
    }
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}